package comm.dhee.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import comm.dhee.dto.M001;
import comm.dhee.dto.T003;

public class TestPR20301 {

	public static void main(String[] args) {

		PR20301DAO pr20301dao = new PR20301DAOImpl();

		try {

			M001 teM001 = new M001();
			teM001 = pr20301dao.salKokyaku("19000");
			System.out.println(teM001.getKokyakuMei());
			System.out.println(teM001.getUrikakeKinZandaka());
			System.out.println("==============================");

			List<T003> juchuuList = new ArrayList<T003>();
			juchuuList = pr20301dao.salJuchuuList("11000");
			for (T003 t003 : juchuuList) {
				System.out.println(t003.getSeikyuushoBangou());
				System.out.println(t003.getSeikyuuHiduke());
				System.out.println(t003.getSuuryouTanka());
			}
			System.out.println("==============================");

			System.out.println(pr20301dao.salNyuukin());
			System.out.println("==============================");

			T003 teT003 = new T003();
			teT003.setSeikyuushoBangou("002");
			teT003.setNyuukinCode("001");
			System.out.println(pr20301dao.upNyuukinCode(teT003));
			System.out.println("==============================");

			System.out.println(pr20301dao.upUrikakeKinZandaka("19000", 10));
			System.out.println("==============================");

			System.out.println(pr20301dao.salJuchuuCode("19000"));

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}
